package com.example.qxfw.backgroundManagement.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.example.qxfw.common.entity.AgriMonitor;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author ZeLin Wang
 * @version 1.0
 * @description: 监控管理-农情监控
 * @date 2024/7/4 9:46
 */
@Mapper
@DS("service")
public interface AgriculturalMonitoringMapper {

    @Select("select * from agri_moni_info")
    List<AgriMonitor> selectAgriMonitorInfo();

    @Select("select stationname from station_info where stationid = #{stationId}")
    String selectStationName(String stationId);
}
